{\rtf1\ansi\ansicpg936\cocoartf1265\cocoasubrtf190
\cocoascreenfonts1{\fonttbl\f0\fswiss\fcharset0 ArialMT;\f1\fnil\fcharset134 STHeitiSC-Light;\f2\fnil\fcharset0 Menlo-Regular;
\f3\fnil\fcharset0 MicrosoftYaHei;}
{\colortbl;\red255\green255\blue255;\red65\green182\blue69;\red38\green38\blue38;\red155\green44\blue1;
\red51\green51\blue51;\red178\green24\blue137;\red120\green109\blue196;\red76\green76\blue76;\red219\green44\blue56;
}
{\*\listtable{\list\listtemplateid1\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\*\levelmarker \{none\}.}{\leveltext\leveltemplateid1\'01.;}{\levelnumbers;}\fi-360\li720\lin720 }{\listname ;}\listid1}}
{\*\listoverridetable{\listoverride\listid1\listoverridecount0\ls1}}
\paperw11900\paperh16840\margl1440\margr1440\vieww12600\viewh9600\viewkind0
\deftab400
\pard\tx400\pardeftab400\pardirnatural

\f0\fs36 \cf2 \CocoaLigature0                                    SQLite
\f1 \'ca\'fd\'be\'dd\'bf\'e2\'bb\'f9\'b1\'be\'d3\'ef\'be\'e4
\f0 \
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardeftab400\li240\fi-240\pardirnatural

\f2\fs22 \cf0 \CocoaLigature1 Ld /Users/apple/Library/Developer/Xcode/DerivedData/Film163-creqqslubvhstsfnqecwkurlzvyd/Build/Products/Debug-iphonesimulator/Film163.app/Film163 normal i386\
\pard\tx400\pardeftab400\pardirnatural

\f0\fs36 \cf2 \CocoaLigature0 \
\
\pard\tx220\tx720\pardeftab720\li720\fi-720\sl560\sa500\qj
\ls1\ilvl0
\f3\fs32 \cf3 \CocoaLigature1 {\listtext	.	}\uc0\u36755 \u20837 \'a0\u26174 \u31034 Mac\u38544 \u34255 \u25991 \u20214 \u30340 \u21629 \u20196 \u65306 defaults write com.apple.finder AppleShowAllFiles -bool true\
\pard\tx566\pardeftab720\sl560\sa500\qj
\cf3 \
\pard\tx400\pardeftab400\pardirnatural

\f1\fs36 \cf4 \CocoaLigature0 \'cc\'da\'d1\'b6\'c6\'f3\'d2\'b5\'d3\'ca\'cf\'e4 
\f0 http://exmail.qq.com\cf2 \
longpc@77ircloud.com\
ios396836731\
\
//1.
\f1 \'bd\'a8\'b1\'ed ios1310301
\f0 \cf5 \
create table book(\cf6 id\cf5 ,title,price,author,publisher,pubdate);\
\pard\tx400\pardeftab400\pardirnatural
\cf2 //2.
\f1 \'b2\'e5\'c8\'eb\'ca\'fd\'be\'dd
\f0 \cf5 \
replace into book(\cf6 id\cf5 ,title,price) values(\cf7 '2'\cf5 ,\cf7 '2book'\cf5 ,\cf7 '2'\cf5 );\
\cf2 //3.
\f1 \'c9\'be\'b3\'fd\'ca\'fd\'be\'dd
\f0 \cf5 \
\pard\tx400\pardeftab400\pardirnatural
\cf6 delete\cf5  from book where \cf6 id\cf5  =\cf7 '2'\cf5 ;\
\pard\tx400\pardeftab400\pardirnatural
\cf2 //4.
\f1 \'b8\'fc\'d0\'c2\'ca\'fd\'be\'dd
\f0 \cf5 \
update book set title=\cf7 '5book'\cf5  where \cf6 id\cf5  = \cf7 '2'\cf5 ;\
\cf2 //5.
\f1 \'b2\'e9\'d1\'af\'ca\'fd\'be\'dd
\f0 \cf5 \
select * from Book where \cf6 id\cf5 >\cf7 3\cf5  limit \cf7 3\cf5 ,\cf7 5\cf5 ;\
\
\cf2 //6.
\f1 \'b4\'b4\'bd\'a8\'b4\'f8\'d6\'f7\'bc\'fc\'b5\'c4\'d7\'d4\'d4\'f6\'b3\'a4
\f0 id
\f1 \'b5\'c4\'b1\'ed
\f0 \cf5 \
create table \cf6 if\cf5  \cf6 not\cf5  exists Book2(\cf6 id\cf5  integer primary key autoincrement ,title ,price,author \cf6 default\cf5  \cf7 'abc'\cf5 ,time timestamp \cf6 default\cf5  current_time );\
\cf2 //7.
\f1 \'b2\'e5\'c8\'eb\'ca\'fd\'be\'dd
\f0 \cf5 \
replace into book2(title,price) values (\cf7 'book3'\cf5 ,\cf7 '7'\cf5 );\
\cf2 //8.
\f1 \'b2\'e9\'d1\'af\'ca\'fd\'be\'dd
\f0 \cf5 \
select * from book2;\
\
\pard\tx400\pardeftab400\pardirnatural

\f1 \cf5 //===============================================\
\
\pard\tx400\pardeftab400\pardirnatural
\cf8 \'bc\'f2\'b5\'a5\'bb\'f9\'b1\'be\'b5\'c4
\f0 sql
\f1 \'d3\'ef\'be\'e4
\f0 \
\
(\cf7 1\cf8 ) 
\f1 \'ca\'fd\'be\'dd\'bc\'c7\'c2\'bc\'c9\'b8\'d1\'a1\'a3\'ba
\f0 \
\
sql=\cf9 "select * from 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  where 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0 =
\f1 \'d7\'d6\'b6\'ce\'d6\'b5
\f0  order by 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0  [desc]"\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "select * from 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  where 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0  like '%
\f1 \'d7\'d6\'b6\'ce\'d6\'b5
\f0 %' order by 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0  [desc]"\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "select top 10 * from 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  where 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0 =
\f1 \'d7\'d6\'b6\'ce\'d6\'b5
\f0  order by 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0  [desc]"\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "select top 10 * from 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  order by 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0  [desc]"\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "select * from 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  where 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0  in ('
\f1 \'d6\'b5
\f0 1','
\f1 \'d6\'b5
\f0 2','
\f1 \'d6\'b5
\f0 3')"\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "select * from 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  where 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0  between 
\f1 \'d6\'b5
\f0 1 and 
\f1 \'d6\'b5
\f0 2"\cf8 \
 \
 \
(\cf7 2\cf8 ) 
\f1 \'b8\'fc\'d0\'c2\'ca\'fd\'be\'dd\'bc\'c7\'c2\'bc\'a3\'ba
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "update 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  set 
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0 =
\f1 \'d7\'d6\'b6\'ce\'d6\'b5
\f0  where 
\f1 \'cc\'f5\'bc\'fe\'b1\'ed\'b4\'ef\'ca\'bd
\f0 "\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "update 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  set 
\f1 \'d7\'d6\'b6\'ce
\f0 1=
\f1 \'d6\'b5
\f0 1,
\f1 \'d7\'d6\'b6\'ce
\f0 2=
\f1 \'d6\'b5
\f0 2 \'85\'85 
\f1 \'d7\'d6\'b6\'ce
\f0 n=
\f1 \'d6\'b5
\f0 n where 
\f1 \'cc\'f5\'bc\'fe\'b1\'ed\'b4\'ef\'ca\'bd
\f0 "\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
 \
(\cf7 3\cf8 ) 
\f1 \'c9\'be\'b3\'fd\'ca\'fd\'be\'dd\'bc\'c7\'c2\'bc\'a3\'ba
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "delete from 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  where 
\f1 \'cc\'f5\'bc\'fe\'b1\'ed\'b4\'ef\'ca\'bd
\f0 "\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "delete from 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0 "\cf8  (
\f1 \'bd\'ab\'ca\'fd\'be\'dd\'b1\'ed\'cb\'f9\'d3\'d0\'bc\'c7\'c2\'bc\'c9\'be\'b3\'fd
\f0 )\

\f1 \'a1\'a1\'a1\'a1
\f0 \
(\cf7 4\cf8 ) 
\f1 \'cc\'ed\'bc\'d3\'ca\'fd\'be\'dd\'bc\'c7\'c2\'bc\'a3\'ba
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "replace into 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  (
\f1 \'d7\'d6\'b6\'ce
\f0 1,
\f1 \'d7\'d6\'b6\'ce
\f0 2,
\f1 \'d7\'d6\'b6\'ce
\f0 3 \'85) values (
\f1 \'d6\'b5
\f0 1,
\f1 \'d6\'b5
\f0 2,
\f1 \'d6\'b5
\f0 3 \'85)"\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "replace into 
\f1 \'c4\'bf\'b1\'ea\'ca\'fd\'be\'dd\'b1\'ed
\f0  select * from 
\f1 \'d4\'b4\'ca\'fd\'be\'dd\'b1\'ed
\f0 "\cf8  (
\f1 \'b0\'d1\'d4\'b4\'ca\'fd\'be\'dd\'b1\'ed\'b5\'c4\'bc\'c7\'c2\'bc\'cc\'ed\'bc\'d3\'b5\'bd\'c4\'bf\'b1\'ea\'ca\'fd\'be\'dd\'b1\'ed
\f0 )\

\f1 \'a1\'a1\'a1\'a1
\f0 \
(\cf7 5\cf8 ) 
\f1 \'ca\'fd\'be\'dd\'bc\'c7\'c2\'bc\'cd\'b3\'bc\'c6\'ba\'af\'ca\'fd\'a3\'ba
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
AVG(
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0 ) 
\f1 \'b5\'c3\'b3\'f6\'d2\'bb\'b8\'f6\'b1\'ed\'b8\'f1\'c0\'b8\'c6\'bd\'be\'f9\'d6\'b5
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
COUNT(*;
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0 ) 
\f1 \'b6\'d4\'ca\'fd\'be\'dd\'d0\'d0\'ca\'fd\'b5\'c4\'cd\'b3\'bc\'c6\'bb\'f2\'b6\'d4\'c4\'b3\'d2\'bb\'c0\'b8\'d3\'d0\'d6\'b5\'b5\'c4\'ca\'fd\'be\'dd\'d0\'d0\'ca\'fd\'cd\'b3\'bc\'c6
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
MAX(
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0 ) 
\f1 \'c8\'a1\'b5\'c3\'d2\'bb\'b8\'f6\'b1\'ed\'b8\'f1\'c0\'b8\'d7\'ee\'b4\'f3\'b5\'c4\'d6\'b5
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
MIN(
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0 ) 
\f1 \'c8\'a1\'b5\'c3\'d2\'bb\'b8\'f6\'b1\'ed\'b8\'f1\'c0\'b8\'d7\'ee\'d0\'a1\'b5\'c4\'d6\'b5
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
SUM(
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0 ) 
\f1 \'b0\'d1\'ca\'fd\'be\'dd\'c0\'b8\'b5\'c4\'d6\'b5\'cf\'e0\'bc\'d3
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \

\f1 \'d2\'fd\'d3\'c3\'d2\'d4\'c9\'cf\'ba\'af\'ca\'fd\'b5\'c4\'b7\'bd\'b7\'a8\'a3\'ba
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
sql=\cf9 "select sum(
\f1 \'d7\'d6\'b6\'ce\'c3\'fb
\f0 ) as 
\f1 \'b1\'f0\'c3\'fb
\f0  from 
\f1 \'ca\'fd\'be\'dd\'b1\'ed
\f0  where 
\f1 \'cc\'f5\'bc\'fe\'b1\'ed\'b4\'ef\'ca\'bd
\f0 "\cf8 \

\f1 \'a1\'a1\'a1\'a1
\f0 \
\pard\tx400\pardeftab400\pardirnatural
\cf2 //set rs=conn.excute(sql)\
\pard\tx400\pardeftab400\pardirnatural

\f1 \cf8 \'cd\'b3\'bc\'c6\'ba\'af\'ca\'fd\'bd\'e1\'b9\'fb\'d3\'c3\'d2\'d4\'cf\'c2\'b6\'c1\'c8\'a1
\f0 \

\f1 int i =\'a1\'a1[results intForColumnIndex:0];\'a1\'a1
\f0 \

\f1 \'d3\'c3
\f0  rs(\cf9 "
\f1 \'b1\'f0\'c3\'fb
\f0 "\cf8 ) 
\f1 \'bb\'f1\'c8\'a1\'cd\'b3\'bc\'c6\'b5\'c4\'d6\'b5\'a3\'ac\'c6\'e4\'cb\'fc\'ba\'af\'ca\'fd\'d4\'cb\'d3\'c3\'cd\'ac\'c9\'cf\'a1\'a3
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 \

\f1 \'b2\'e9\'d1\'af\'c8\'a5\'b3\'fd\'d6\'d8\'b8\'b4\'d6\'b5\'a3\'ba
\f0 select distinct * from table1\

\f1 \'a1\'a1\'a1\'a1
\f0 \
(\cf7 6\cf8 ) 
\f1 \'ca\'fd\'be\'dd\'b1\'ed\'b5\'c4\'bd\'a8\'c1\'a2\'ba\'cd\'c9\'be\'b3\'fd\'a3\'ba
\f0 \

\f1 \'a1\'a1\'a1\'a1
\f0 CREATE TABLE 
\f1 \'ca\'fd\'be\'dd\'b1\'ed\'c3\'fb\'b3\'c6
\f0 (
\f1 \'d7\'d6\'b6\'ce
\f0 \cf7 1\cf8  
\f1 \'c0\'e0\'d0\'cd
\f0 \cf7 1\cf8 (
\f1 \'b3\'a4\'b6\'c8
\f0 ),
\f1 \'d7\'d6\'b6\'ce
\f0 \cf7 2\cf8  
\f1 \'c0\'e0\'d0\'cd
\f0 \cf7 2\cf8 (
\f1 \'b3\'a4\'b6\'c8
\f0 ) \'85\'85 )\
\
}